YData Profiling Report

Brought to you by YData

Dataset statistics

Number of variables	12
Number of observations	2774
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	281.7 KiB
Average record size in memory	104.0 B

Variable types

Numeric	12

Alerts

`avg_basket_size` is highly overall correlated with `gross_revenue` and 1 other fields	High correlation
`avg_recency_days` is highly overall correlated with `frequency`	High correlation
`avg_ticket` is highly overall correlated with `avg_unique_basket_size`	High correlation
`avg_unique_basket_size` is highly overall correlated with `avg_ticket` and 1 other fields	High correlation
`frequency` is highly overall correlated with `avg_recency_days`	High correlation
`gross_revenue` is highly overall correlated with `avg_basket_size` and 3 other fields	High correlation
`qtde_produtcs` is highly overall correlated with `avg_unique_basket_size` and 3 other fields	High correlation
`qte_invoices` is highly overall correlated with `gross_revenue` and 2 other fields	High correlation
`qte_items` is highly overall correlated with `avg_basket_size` and 3 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 51.90076813)	Skewed
`frequency` is highly skewed (γ1 = 46.08548575)	Skewed
`qtde_returns` is highly skewed (γ1 = 50.10197766)	Skewed
`avg_basket_size` is highly skewed (γ1 = 44.87225707)	Skewed
`customer_id` has unique values	Unique
`recency_days` has 34 (1.2%) zeros	Zeros
`qtde_returns` has 1481 (53.4%) zeros	Zeros

Reproduction

Analysis started	2025-04-09 18:26:19.235133
Analysis finished	2025-04-09 18:27:22.866036
Duration	1 minute and 3.63 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

customer_id
Real number (ℝ)

Unique

Distinct	2774
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15285.7

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	12347
5-th percentile	12626.65
Q1	13815.25
median	15242.5
Q3	16779.75
95-th percentile	17950.35
Maximum	18287
Range	5940
Interquartile range (IQR)	2964.5

Descriptive statistics

Standard deviation	1714.9849
Coefficient of variation (CV)	0.11219538
Kurtosis	-1.2069151
Mean	15285.7
Median Absolute Deviation (MAD)	1483.5
Skewness	0.015990788
Sum	42402531
Variance	2941173.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
14482	1	< 0.1%
17058	1	< 0.1%
17704	1	< 0.1%
16933	1	< 0.1%
13772	1	< 0.1%
16249	1	< 0.1%
14198	1	< 0.1%
13989	1	< 0.1%
17930	1	< 0.1%
Other values (2764)	2764	99.6%

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12364	1	< 0.1%
12370	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18265	1	< 0.1%
18263	1	< 0.1%
18261	1	< 0.1%
18260	1	< 0.1%

gross_revenue
Real number (ℝ)

High correlation

Distinct	2760
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2904.6492

Minimum	36.56
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	36.56
5-th percentile	264.557
Q1	628.195
median	1170.87
Q3	2423.86
95-th percentile	7579.4915
Maximum	279138.02
Range	279101.46
Interquartile range (IQR)	1795.665

Descriptive statistics

Standard deviation	10927.083
Coefficient of variation (CV)	3.7619287
Kurtosis	331.96378
Mean	2904.6492
Median Absolute Deviation (MAD)	690.475
Skewness	16.261241
Sum	8057496.7
Variance	1.1940114 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1025.44	2	0.1%
745.06	2	0.1%
598.2	2	0.1%
1078.96	2	0.1%
731.9	2	0.1%
1353.74	2	0.1%
2053.02	2	0.1%
379.65	2	0.1%
1314.45	2	0.1%
331	2	0.1%
Other values (2750)	2754	99.3%

Value	Count	Frequency (%)
36.56	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%
70.02	1	< 0.1%
77.4	1	< 0.1%
84.65	1	< 0.1%
90.3	1	< 0.1%
93.35	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
140438.72	1	< 0.1%
124564.53	1	< 0.1%
117375.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%

recency_days
Real number (ℝ)

Zeros

Distinct	252
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.627974

Minimum	0
Maximum	372
Zeros	34
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	10
median	29
Q3	73
95-th percentile	211
Maximum	372
Range	372
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	68.419023
Coefficient of variation (CV)	1.2082195
Kurtosis	3.4321191
Mean	56.627974
Median Absolute Deviation (MAD)	23.5
Skewness	1.8983643
Sum	157086
Variance	4681.1627
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.6%
4	87	3.1%
2	85	3.1%
3	85	3.1%
8	76	2.7%
10	67	2.4%
9	66	2.4%
7	65	2.3%
17	62	2.2%
22	55	2.0%
Other values (242)	2027	73.1%

Value	Count	Frequency (%)
0	34	1.2%
1	99	3.6%
2	85	3.1%
3	85	3.1%
4	87	3.1%
5	43	1.6%
7	65	2.3%
8	76	2.7%
9	66	2.4%
10	67	2.4%

Value	Count	Frequency (%)
372	1	< 0.1%
366	1	< 0.1%
360	1	< 0.1%
358	3	0.1%
354	1	< 0.1%
337	1	< 0.1%
336	2	0.1%
334	1	< 0.1%
333	2	0.1%
330	1	< 0.1%

qte_invoices
Real number (ℝ)

High correlation

Distinct	55
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.0529921

Minimum	2
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	204
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	9.071603
Coefficient of variation (CV)	1.4986973
Kurtosis	183.94516
Mean	6.0529921
Median Absolute Deviation (MAD)	2
Skewness	10.624664
Sum	16791
Variance	82.293981
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	781	28.2%
3	498	18.0%
4	393	14.2%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%
Other values (45)	278	10.0%

Value	Count	Frequency (%)
2	781	28.2%
3	498	18.0%
4	393	14.2%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

qte_items
Real number (ℝ)

High correlation

Distinct	1632
Distinct (%)	58.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1697.8205

Minimum	2
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2
5-th percentile	119
Q1	330.25
median	699.5
Q3	1478
95-th percentile	4645.5
Maximum	196844
Range	196842
Interquartile range (IQR)	1147.75

Descriptive statistics

Standard deviation	6074.4301
Coefficient of variation (CV)	3.5777812
Kurtosis	438.72722
Mean	1697.8205
Median Absolute Deviation (MAD)	449
Skewness	17.339197
Sum	4709754
Variance	36898701
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
246	8	0.3%
150	8	0.3%
200	7	0.3%
219	7	0.3%
260	7	0.3%
394	7	0.3%
272	7	0.3%
516	7	0.3%
300	7	0.3%
Other values (1622)	2698	97.3%

Value	Count	Frequency (%)
2	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
25	1	< 0.1%
27	2	0.1%
30	1	< 0.1%
32	1	< 0.1%
33	2	0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
79963	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
62812	1	< 0.1%
58243	1	< 0.1%
57785	1	< 0.1%

qtde_produtcs
Real number (ℝ)

High correlation

Distinct	468
Distinct (%)	16.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	129.72314

Minimum	2
Maximum	7837
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2
5-th percentile	10
Q1	34
median	72
Q3	143
95-th percentile	400.05
Maximum	7837
Range	7835
Interquartile range (IQR)	109

Descriptive statistics

Standard deviation	277.72934
Coefficient of variation (CV)	2.140939
Kurtosis	336.80085
Mean	129.72314
Median Absolute Deviation (MAD)	45
Skewness	15.347204
Sum	359852
Variance	77133.584
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	40	1.4%
35	34	1.2%
27	30	1.1%
26	30	1.1%
29	28	1.0%
31	27	1.0%
15	27	1.0%
33	27	1.0%
25	26	0.9%
42	26	0.9%
Other values (458)	2479	89.4%

Value	Count	Frequency (%)
2	11	0.4%
3	13	0.5%
4	16	0.6%
5	16	0.6%
6	24	0.9%
7	14	0.5%
8	13	0.5%
9	20	0.7%
10	18	0.6%
11	23	0.8%

Value	Count	Frequency (%)
7837	1	< 0.1%
5670	1	< 0.1%
5095	1	< 0.1%
4577	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1636	1	< 0.1%

avg_ticket
Real number (ℝ)

High correlation Skewed

Distinct	2772
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.33923

Minimum	2.1505882
Maximum	56157.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	2.1505882
5-th percentile	4.8527022
Q1	12.426548
median	17.946876
Q3	25.074658
95-th percentile	88.427443
Maximum	56157.5
Range	56155.349
Interquartile range (IQR)	12.64811

Descriptive statistics

Standard deviation	1071.0491
Coefficient of variation (CV)	20.463601
Kurtosis	2718.3215
Mean	52.33923
Median Absolute Deviation (MAD)	6.3338406
Skewness	51.900768
Sum	145189.02
Variance	1147146.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
14.47833333	2	0.1%
4.162	2	0.1%
6.269700855	1	< 0.1%
32.59775	1	< 0.1%
19.03048387	1	< 0.1%
28.55451613	1	< 0.1%
12.80068182	1	< 0.1%
6.396214689	1	< 0.1%
26.08797101	1	< 0.1%
17.98461538	1	< 0.1%
Other values (2762)	2762	99.6%

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.770464191	1	< 0.1%

Value	Count	Frequency (%)
56157.5	1	< 0.1%
4453.43	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%
651.1683333	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%
615.75	1	< 0.1%

avg_recency_days
Real number (ℝ)

High correlation

Distinct	1155
Distinct (%)	41.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	78.801889

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	1
5-th percentile	13
Q1	34.241667
median	59
Q3	99
95-th percentile	224
Maximum	366
Range	365
Interquartile range (IQR)	64.758333

Descriptive statistics

Standard deviation	66.515011
Coefficient of variation (CV)	0.84407889
Kurtosis	3.6744362
Mean	78.801889
Median Absolute Deviation (MAD)	30
Skewness	1.8283611
Sum	218596.44
Variance	4424.2467
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
70	21	0.8%
46	18	0.6%
55	17	0.6%
31	16	0.6%
91	16	0.6%
49	16	0.6%
21	15	0.5%
42	15	0.5%
35	15	0.5%
14	14	0.5%
Other values (1145)	2611	94.1%

Value	Count	Frequency (%)
1	9	0.3%
2	4	0.1%
2.861538462	1	< 0.1%
3	6	0.2%
3.330357143	1	< 0.1%
3.351351351	1	< 0.1%
4	5	0.2%
4.191011236	1	< 0.1%
4.275862069	1	< 0.1%
4.5	1	< 0.1%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
364	1	< 0.1%
363	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

frequency
Real number (ℝ)

High correlation Skewed

Distinct	1225
Distinct (%)	44.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.049692192

Minimum	0.0054495913
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	0.0054495913
5-th percentile	0.0087463557
Q1	0.015758392
median	0.024390244
Q3	0.041666667
95-th percentile	0.11538462
Maximum	17
Range	16.99455
Interquartile range (IQR)	0.025908275

Descriptive statistics

Standard deviation	0.337595
Coefficient of variation (CV)	6.7937233
Kurtosis	2296.5219
Mean	0.049692192
Median Absolute Deviation (MAD)	0.010694545
Skewness	46.085486
Sum	137.84614
Variance	0.11397038
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0625	17	0.6%
0.02777777778	17	0.6%
0.02380952381	16	0.6%
0.08333333333	15	0.5%
0.09090909091	15	0.5%
0.03448275862	14	0.5%
0.02941176471	14	0.5%
0.07692307692	13	0.5%
0.02127659574	13	0.5%
0.02564102564	13	0.5%
Other values (1215)	2627	94.7%

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
3	1	< 0.1%
2	1	< 0.1%
1.142857143	1	< 0.1%
1	8	0.3%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%
0.5	3	0.1%

qtde_returns
Real number (ℝ)

Skewed Zeros

Distinct	205
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.158976

Minimum	0
Maximum	80995
Zeros	1481
Zeros (%)	53.4%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	9
95-th percentile	98
Maximum	80995
Range	80995
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	1564.3935
Coefficient of variation (CV)	24.383081
Kurtosis	2586.2541
Mean	64.158976
Median Absolute Deviation (MAD)	0
Skewness	50.101978
Sum	177977
Variance	2447327.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1481	53.4%
1	129	4.7%
2	117	4.2%
3	82	3.0%
4	72	2.6%
6	63	2.3%
5	55	2.0%
12	45	1.6%
8	39	1.4%
9	38	1.4%
Other values (195)	653	23.5%

Value	Count	Frequency (%)
0	1481	53.4%
1	129	4.7%
2	117	4.2%
3	82	3.0%
4	72	2.6%
5	55	2.0%
6	63	2.3%
7	38	1.4%
8	39	1.4%
9	38	1.4%

Value	Count	Frequency (%)
80995	1	< 0.1%
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%

avg_basket_size
Real number (ℝ)

High correlation Skewed

Distinct	1932
Distinct (%)	69.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	245.46514

Minimum	1
Maximum	40498.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	1
5-th percentile	45
Q1	103.33333
median	172
Q3	278.17381
95-th percentile	585.55
Maximum	40498.5
Range	40497.5
Interquartile range (IQR)	174.84048

Descriptive statistics

Standard deviation	808.02308
Coefficient of variation (CV)	3.2918039
Kurtosis	2224.0987
Mean	245.46514
Median Absolute Deviation (MAD)	81
Skewness	44.872257
Sum	680920.29
Variance	652901.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
86	9	0.3%
60	8	0.3%
75	8	0.3%
82	7	0.3%
208	7	0.3%
105	7	0.3%
136	7	0.3%
197	7	0.3%
73	7	0.3%
Other values (1922)	2696	97.2%

Value	Count	Frequency (%)
1	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%
11.875	1	< 0.1%

Value	Count	Frequency (%)
40498.5	1	< 0.1%
6009.333333	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%
2082.225806	1	< 0.1%
2000	1	< 0.1%
1903.5	1	< 0.1%

avg_unique_basket_size
Real number (ℝ)

High correlation

Distinct	902
Distinct (%)	32.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.135898

Minimum	0.2
Maximum	177
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	43.3 KiB

Quantile statistics

Minimum	0.2
5-th percentile	2
Q1	7.5113636
median	13.5
Q3	22
95-th percentile	45.0875
Maximum	177
Range	176.8
Interquartile range (IQR)	14.488636

Descriptive statistics

Standard deviation	14.265567
Coefficient of variation (CV)	0.83249604
Kurtosis	9.9898011
Mean	17.135898
Median Absolute Deviation (MAD)	6.6666667
Skewness	2.2440267
Sum	47534.982
Variance	203.50641
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	34	1.2%
8	34	1.2%
16	34	1.2%
9	33	1.2%
7	32	1.2%
12	30	1.1%
18.5	29	1.0%
6	29	1.0%
7.5	28	1.0%
17	28	1.0%
Other values (892)	2463	88.8%

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	6	0.2%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.4%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%
0.6176470588	1	< 0.1%

Value	Count	Frequency (%)
177	1	< 0.1%
105	1	< 0.1%
104	1	< 0.1%
98	1	< 0.1%
95.5	1	< 0.1%
94.33333333	1	< 0.1%
93	1	< 0.1%
89.625	1	< 0.1%
87	1	< 0.1%
85.66666667	1	< 0.1%

	avg_basket_size	avg_recency_days	avg_ticket	avg_unique_basket_size	customer_id	frequency	gross_revenue	qtde_produtcs	qtde_returns	qte_invoices	qte_items	recency_days
avg_basket_size	1.000	-0.042	0.199	0.383	-0.120	0.025	0.602	0.402	0.215	0.125	0.759	-0.104
avg_recency_days	-0.042	1.000	-0.079	0.186	-0.012	-0.952	-0.366	-0.301	-0.214	-0.477	-0.342	0.223
avg_ticket	0.199	-0.079	1.000	-0.639	-0.141	0.081	0.274	-0.382	0.189	0.090	0.196	0.034
avg_unique_basket_size	0.383	0.186	-0.639	1.000	-0.001	-0.165	0.102	0.547	-0.065	-0.179	0.146	0.006
customer_id	-0.120	-0.012	-0.141	-0.001	1.000	0.013	-0.085	0.012	-0.058	0.013	-0.078	0.013
frequency	0.025	-0.952	0.081	-0.165	0.013	1.000	0.258	0.202	0.175	0.322	0.239	-0.126
gross_revenue	0.602	-0.366	0.274	0.102	-0.085	0.258	1.000	0.722	0.462	0.762	0.922	-0.374
qtde_produtcs	0.402	-0.301	-0.382	0.547	0.012	0.202	0.722	1.000	0.328	0.659	0.707	-0.391
qtde_returns	0.215	-0.214	0.189	-0.065	-0.058	0.175	0.462	0.328	1.000	0.425	0.427	-0.187
qte_invoices	0.125	-0.477	0.090	-0.179	0.013	0.322	0.762	0.659	0.425	1.000	0.703	-0.447
qte_items	0.759	-0.342	0.196	0.146	-0.078	0.239	0.922	0.707	0.427	0.703	1.000	-0.366
recency_days	-0.104	0.223	0.034	0.006	0.013	-0.126	-0.374	-0.391	-0.187	-0.447	-0.366	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	customer_id	gross_revenue	recency_days	qte_invoices	qte_items	qtde_produtcs	avg_ticket	avg_recency_days	frequency	qtde_returns	avg_basket_size	avg_unique_basket_size
0	17850	5391.21	372.0	34.0	1733.0	297.0	18.152222	1.000000	17.000000	40.0	50.970588	0.617647
1	13047	3232.59	56.0	9.0	1390.0	171.0	18.904035	52.833333	0.028302	35.0	154.444444	11.666667
2	12583	6705.38	2.0	15.0	5028.0	232.0	28.902500	26.500000	0.040323	50.0	335.200000	7.600000
3	13748	948.25	95.0	5.0	439.0	28.0	33.866071	92.666667	0.017921	0.0	87.800000	4.800000
4	15100	876.00	333.0	3.0	80.0	3.0	292.000000	20.000000	0.073171	22.0	26.666667	0.333333
5	15291	4623.30	25.0	14.0	2102.0	102.0	45.326471	26.769231	0.040115	29.0	150.142857	4.357143
6	14688	5630.87	7.0	21.0	3621.0	327.0	17.219786	19.263158	0.057221	399.0	172.428571	7.047619
7	17809	5411.91	16.0	12.0	2057.0	61.0	88.719836	39.666667	0.033520	41.0	171.416667	3.833333
8	15311	60767.90	0.0	91.0	38194.0	2379.0	25.543464	4.191011	0.243316	474.0	419.714286	6.230769
9	16098	2005.63	87.0	7.0	613.0	67.0	29.934776	47.666667	0.024390	0.0	87.571429	4.857143

	customer_id	gross_revenue	recency_days	qte_invoices	qte_items	qtde_produtcs	avg_ticket	avg_recency_days	frequency	qtde_returns	avg_basket_size	avg_unique_basket_size
5611	17290	525.24	3.0	2.0	404.0	102.0	5.149412	13.0	0.142857	0.0	202.000000	46.000000
5620	14785	77.40	10.0	2.0	84.0	3.0	25.800000	5.0	0.333333	0.0	42.000000	1.000000
5621	17254	272.44	4.0	2.0	252.0	112.0	2.432500	11.0	0.166667	0.0	126.000000	50.000000
5637	17232	421.52	2.0	2.0	203.0	36.0	11.708889	12.0	0.153846	0.0	101.500000	15.000000
5638	17468	137.00	10.0	2.0	116.0	5.0	27.400000	4.0	0.400000	0.0	58.000000	2.500000
5649	13596	697.04	5.0	2.0	406.0	166.0	4.199036	7.0	0.250000	0.0	203.000000	66.500000
5655	14893	1237.85	9.0	2.0	799.0	73.0	16.956849	2.0	0.666667	0.0	399.500000	36.000000
5680	14126	706.13	7.0	3.0	508.0	15.0	47.075333	3.0	0.750000	50.0	169.333333	4.666667
5686	13521	1092.39	1.0	3.0	733.0	435.0	2.511241	4.5	0.300000	0.0	244.333333	104.000000
5696	15060	301.84	8.0	4.0	262.0	120.0	2.515333	1.0	2.000000	0.0	65.500000	20.000000

Overview

Interactions

Correlations

Missing values

Sample

Overview

Variables

Interactions

Correlations

Missing values

Sample